/*  Bootstrap master file. Creates Table A.5.

NOTES:

*/

clear all

*change "mainpath" below to your folder location
global mainpath `"Z:/user/rih4/Solar Siting"'

*shouldn't need to change these paths if your folders are named the same
cd `"${mainpath}/JAERE Code Repository"'
global data_path `"Data JAERE"'
global data_intermediate `"${data_path}/intermediate_output"'
global data_final `"${data_path}/final_output"'
global reallocation_scripts `"Scripts - Reallocation Simulations"'

putexcel set `"${data_final}/tableA5.xlsx"', sheet(sheet1) replace
putexcel A1 = "Reallocation"
putexcel B1 = "Mean"
putexcel C1 = "St. Dev."
putexcel D1 = "2.5 Percentile"
putexcel E1 = "97.5 Percentile"

putexcel A2 = "WECC Interstate"
putexcel A3 = "WECC Intrastate"
putexcel A4 = "Texas"

do `"${reallocation_scripts}/Reshape_bootstraps_wide.do"'
do `"${reallocation_scripts}/Reallocation_Texas_bootstraps.do"'
do `"${reallocation_scripts}/Reallocation_WECC_bootstraps.do"'
do `"${reallocation_scripts}/Reallocation_Intrastate_WECC_bootstraps.do"'